Working Capital is in a bad place for RDUS as they are relying more on long-term debt to finance asset requirements and have very little to no cash at all. As shown in the Financial leverage figure. RDUS is already hurting from the amount of debt they have, and the green line suggests they will be better off not taking on debt. Given this scenario, RDUS would be better off keeping a compromise policy by relying more on short-term borrowing, and as suggested in term report 2, for them to sell some of their underperforming assets and focus on improving liquidity.
The figure below has 3 markers for each line. The markers represent 3 scenarios: Recession, current, and boom. The left marker represents RDUS financial leverage during a hypothetical recession, the middle marker is as the economy is now, and the right marker represents a boom in the economy.
The financial leverage of RDUS would suggest not to take on debt, and consider selling underperforming assets as mentioned in term two report. Later research on this report would support that the economy is heading closer to a recession than a boom so RDUS is better off with no debt. In relation to this project, RDUS is better off using short-term debt and liquidity to finance their working capital, and it will be explained below.
Current trends in ARS for RDUS
Looking at the Scatterplots below, we can see RDUS and its competitors would benefit from increasing credit, besides NVRI, which is worse off extending credit. RDUS Net Income shows that other things affect it most, compared to CLH, where AR explains 66% of the changes in Net Income.
Value of Credit Analysis scatterplots for all firms
We can see RDUS would benefit from extending credit as it tends to benefit when it has more accounts receivables, but the standard deviation is large for both net income and accounts receivables. Two of the lowest markers for RDUS are from the last two quarters of 2023. In Q3, they had NI of -25m and AR of 210m, and in Q4, they had an NI of -17m and AR of 218m. This is not good as their historical average is NI: 19m and AR: 194m, and their average for the 10 lowest quarters of AR from 2016 to 2023 is NI: 8m and AR: 134m.
RDUS Value of Credit Analysis Scatter Plot
Show the code
# scatter plot for only one firm. Value of credit analysis, ch20 slide 18import pandas as pdimport plotly.graph_objects as goimport numpy as npfrom scipy import statsdf = pd.read_excel("C://Users//User//OneDrive - BYU-Idaho//BYUI//2024_1 Winter//455 ECON//1 Final term paper//data//DATAVS.xlsx")x, y = df['11Accounts_Receivable_Trade_RDUS'], df['9Net_Income_Available_to_Common_RDUS']mask =~np.isnan(x) &~np.isnan(y)x_filt, y_filt = x[mask], y[mask]slope, intercept, r_value, p_value, std_err = stats.linregress(x_filt, y_filt)std_x, std_y = np.std(x_filt), np.std(y_filt)fig = go.Figure()fig.add_trace(go.Scatter(x=x_filt, y=y_filt, mode='markers', name='RDUS Data'))fig.add_trace(go.Scatter(x=x_filt, y=intercept + slope * x_filt, mode='lines', name='Trendline', line=dict(color='red', dash='dash')))fig.update_layout(title='RDUS Scatterplot with Trendline', xaxis_title='Accounts Receivable', yaxis_title='Net Income', showlegend=False, annotations=[dict(x=np.max(x_filt), y=np.min(y_filt), xref='x', yref='y', text=f'Y = {slope:.2f}X + {intercept:.2f}<br>R² = {r_value**2:.2f}<br>St_Dev X:{std_x:.0f} St_Dev Y:{std_y:.0f}', showarrow=False)])fig.show()
The linear regression reveals an R-squared of 0.18 with NI as the dependent variable, and AR as the independent variable. The investment in receivables only explains 18% of the changes in Net Income. Based on the investment in receivables research, RDUS can benefit from extending the credit as the scatter plots show NI will go up. Yet, the fact this method only explains 18% of NI, and the last two quarters from 2023, RDUS had higher than average AR, but nearly 200% below the average for NI. The standard deviation for RDUS in this Scatterplot is 24m, but their average for the last two quarters in 2022 is approximately 40m. This shows that RDUS can increase credit, but the 82% not explained by this linear regression is alarming, and extending credit will not help RDUS based on their recent history.
Permanent Working Capital and Book Leverage
RDUS’s permanent working capital needs are increasing, primarily due to its expansion and operational inefficiencies. This increase in permanent working capital needs significantly affects the company’s book leverage. To meet these growing working capital requirements, RDUS has been increasingly relying on long-term debt. This is evident from the rising debt-equity ratio and equity multiplier, as highlighted in the term two report. This heightened dependency on debt alters the company’s capital structure, making it more leveraged.
The effects of this increased leverage are multifaceted. Firstly, it leads to a higher weighted average cost of capital (WACC), as borrowing costs rise with the increased perception of risk by creditors. This higher WACC, in turn, affects the company’s investment decisions and could potentially lower its valuation.
The reliance on debt puts a strain on RDUS’s liquidity, as seen in the declining current and quick ratios. This situation implies that the company might struggle to meet its short-term obligations, thereby increasing financial risk.
The shift towards debt financing, while providing necessary funds in the short term, has negative implications for the company’s long-term financial health. It increases the risk of financial distress, especially if RDUS is unable to generate sufficient cash flows to service its debt obligations.
time series graph of Book leverage
Show the code
# time series graph of Book leverageimport pandas as pdimport plotly.graph_objects as godf = pd.read_excel("C://Users//User//OneDrive - BYU-Idaho//BYUI//2024_1 Winter//455 ECON//1 Final term paper//data//DATAVS.xlsx")q_rdus = df['Q_RDUS'] book_leverage_rdus = df['43Book Leverage_RDUS']fig = go.Figure()fig.add_trace(go.Scatter(x=q_rdus, y=book_leverage_rdus, mode='lines+markers', name='Book Leverage'))fig.update_layout(title='Relationship of RDUS with Book Leverage', xaxis_title='Quaters', yaxis_title='Book Leverage', legend_title='Variable') # edit textfig.show()
RDUS’s increasing permanent working capital needs have led to a more leveraged book position, as indicated by its growing reliance on long-term debt. This shift in capital structure not only raises the company’s financial risks but also impacts its cost of capital and overall financial flexibility. To mitigate these issues, RDUS might need to explore strategies to improve its operational efficiency, reduce debt, and potentially rebalance its capital structure towards a more sustainable model.
Temporary Cash Surpluses, Marketable Securities, and Idle Cash
Given RDUS’s challenging working capital situation and their increasing reliance on long-term debt, it seems possible that temporary cash surpluses might indeed be necessary. These surpluses could serve as a buffer against liquidity constraints, especially since access to marketable securities appears to be limited, likely due to a decrease in such holdings to manage short-term financial obligations.
Common stock vs last price graph
Show the code
# Common stock vs last price graph import pandas as pdimport plotly.graph_objects as godf=pd.read_excel("C://Users//User//OneDrive - BYU-Idaho//BYUI//2024_1 Winter//455 ECON//1 Final term paper//data//DATAVS.xlsx")q, common_stock, last_price=df['Q_RDUS'],df['25Common Stock_RDUS'],df['24Last Price_RDUS']fig=go.Figure()fig.add_trace(go.Scatter(x=q,y=common_stock,mode='lines+markers',name='Common Stock'))fig.add_trace(go.Scatter(x=q,y=last_price,mode='lines+markers',name='Last Price',yaxis='y2'))fig.update_layout(title='Common Stock vs Last Price',xaxis_title='Quarters',yaxis=dict(title='Common Stock (in thousands)',side='left'),yaxis2=dict(title='Last Price',side='right',overlaying='y',showgrid=False),legend_title='Variable')fig.show()
RDUS might find itself with idle cash for several reasons, such as conservative cash management practices amidst economic uncertainty or perhaps due to timing differences between cash inflows from operations or financing activities and cash outflows for investments or debt servicing. The recent negative trends in net income and the increase in accounts receivable could indicate a mismatch in the cash conversion cycle, resulting in idle cash.
Analysis of Firm’s Receivable Investments
RDUS’s investment in receivables, at 11% of total assets for the fourth quarter of 2023, represents a considerable allocation of resources, slightly below the seven-year quarterly average of 14%. This indicates a slight recent decline in the proportion of assets tied up in receivables. Looking at the trend in the days accounts receivable, represented by the blue line, there appears to be significant variability, with some peaks and troughs indicating a fluctuating collection period. It’s clear there are cycles where the days receivable increase sharply, suggesting periods where RDUS may struggle to collect payments promptly. This inconsistency could impact liquidity and cash flow management.
Time Series: Trend and Cycle for RDUS days accounts
Show the code
# time series for RDUS days accounts import pandas as pdimport plotly.graph_objects as godf = pd.read_excel("C://Users//User//OneDrive - BYU-Idaho//BYUI//2024_1 Winter//455 ECON//1 Final term paper//data//DATAVS.xlsx")q_rdus = df['Q_RDUS'] # edit variabledays_sales_receivables_rdus = df["60Day's sales in receivables_RDUS"] # edit variabledays_sales_inventory_rdus = df["58Day's sales in inventory_RDUS"] # edit variablepayable_turnover_rdus = df['62payable turnover_RDUS'] # edit variablefig = go.Figure()fig.add_trace(go.Scatter(x=q_rdus, y=days_sales_receivables_rdus, mode='lines+markers', name="Receivables")) # edit names/titlesfig.add_trace(go.Scatter(x=q_rdus, y=days_sales_inventory_rdus, mode='lines+markers', name="Inventory")) # edit names/titlesfig.add_trace(go.Scatter(x=q_rdus, y=payable_turnover_rdus, mode='lines+markers', name='Payable')) # edit names/titlesfig.update_layout(title='Time Series line Grpah for RDUS Days accounts variables: Receivables, Inventory, and Payables', xaxis_title='', yaxis=dict(title="Days", side='left'), legend_title='Variable') # edit names/titlesfig.show()
In contrast, the days accounts payable, denoted by the green line, show less volatility, with generally more stable, albeit still fluctuating, periods indicating the company’s payment to its suppliers. The trend seems to be moderately cyclic, with no dramatic spikes similar to those seen in receivables. This relative stability in payables suggests a more consistent approach to managing payables compared to receivables. The firm’s strategy for managing payables may reflect an attempt to maintain cash on hand or favorable credit terms with suppliers.
A normal yield curve indicates a healthy economy, while a flat yield curve (when the spread is almost zero) would signal uncertainty about future economic growth, and an inverted yield curve is where short-term yields are higher than long term yields. An inverted yield curve is a warning sign for economic recession.
In the graph below we always want the 10 year US treasury note yield (DGS10: royalblue line) to be above the 3 year yield (DTB3: green line). We also want The fed funds rate (FEDFUNDS: purple line) to be below the 10 year yield.
The Recession Indicator (JHDUSRGDPBR) figure has two lines, the spread line represents the spread between the 10-year and the 3-year yields or 10y yield minus the 3-year yield. A high spread correlates with a healthy economy, and a negative spread, like the 2/10 curve example from the quoted article, would signal warnings of inflation. The second line ‘JHDUSRGDPBR’ is a recession indicator. A 1 in the recession indicator basically means that there would or probably will be a recession in about 4 quarters. For example, looking at the figure, the JHDUS line had a 1 in early 2020, and we were supposed to hit a recession early 2021, or so we thought. We supposedly haven’t hit a recession. The yield curve for the 3/10 has been negative since October 2022, so that is a good warning for an economic recession. The Recession Indicator is still at zero, but based on this analysis and to answer the question of the project, RDUS is better off with short-term financing.
Since October 2022, the 10-year Treasury yield (long-term rate) has been below the 3-year Treasury yield, while the 3-year Treasury yield (short-term rate) has been above the long-term rate. Given that the long-term rate is lower than the current short-term rate, it suggests that interest rates are expected to decrease (the Fed is siding with lowering the rates rather than increasing as well). In such a scenario, it is advantageous for RDUS to finance working capital with short-term debt, with the expectation of refinancing at lower rates in the future. Doing the calculations in the term 4 instructions using the yields for 2023 would also suggest the short-term option to finance working capital.
RDUS’s bad investment decisions and poor capital structure have not put them in a good place, and with the negative yield curve, it is not looking good for the economy. RDUS can explore opportunities like selling underperforming assets, of which they have plenty, as this will help lower their operating costs, decrease expenses, and alleviate some of their debt, as many of their assets are tied to long and short-term debt, as well as contractual obligations. Another opportunity for RDUS is to prepare for bankruptcy and see how to best lower the cost of bankruptcy and maximize the value of their assets before selling.
Conclusion
I found that RDUS’s working capital position is weak, largely due to an over-reliance on long-term debt and insufficient cash reserves. This situation suggests that a compromise policy, balancing short-term borrowing with the sale of underperforming assets to improve liquidity, would be more beneficial. The financial leverage analysis indicates that RDUS should avoid further debt, especially with the economic indicators pointing towards a recession. This approach aligns with the company’s need to manage working capital more effectively using short-term debt.
Regarding receivables, RDUS would benefit from extending credit as it positively impacts their net income, but the impact is limited, explaining only 18% of net income variations. The trend in accounts receivable indicates inconsistent collection periods, which complicates cash flow management. RDUS’s increasing permanent working capital needs and growing reliance on long-term debt have led to higher financial risks, including a more leveraged book position and a higher weighted average cost of capital.
Considering the yield curve analysis, the economic indicators suggest a looming recession. This scenario makes short-term debt financing more favorable for RDUS, allowing for refinancing at potentially lower rates in the future. To address its poor investment decisions and capital structure, RDUS should consider selling underperforming assets to reduce debt and prepare for a potential economic downturn “possible bankrupcty”.